SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 50862: "java.lang.StackTraceElement - Could not execute JDBC batch update..." might be generated

DetailsAboutRate It

The following exception might be generated in SAS® Promotion Optimization when attempting to approve a promotion or run a business rule check on a promotion:

FATAL Worker-3 java.lang.StackTraceElement - Could not execute JDBC batch update org.hibernate.QueryTimeoutException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206) at com.sas.solutions.di.server.db.PersistenceManager.endHiberateTxn(PersistenceManager.java:846) at com.sas.solutions.di.server.db.PersistenceManager.commit(PersistenceManager.java:730) at com.sas.solutions.di.server.util.Interceptors.privateInvoke(Interceptors.java:171) at com.sas.solutions.di.server.spring.SpringServer.invoke(SpringServer.java:170) at com.sas.solutions.di.server.spring.SessionRemoteInvocationExecutor.invoke(SessionRemoteInvocationExecutor.java:46) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114) at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73) at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:662) at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:47) at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115) at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85) at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:148) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy19.save(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sas.solutions.di.server.api.ServerProxy.invoke(ServerProxy.java:60) at $Proxy20.save(Unknown Source) at com.sas.solutions.di.studio.rpp.jobs.plan.UpdateSinglePromotionPlanJob.savePlan(UpdateSinglePromotionPlanJob.java:34) at com.sas.solutions.di.studio.rpp.jobs.plan.UpdateSinglePromotionPlanJob.saveItems(UpdateSinglePromotionPlanJob.java:28) at com.sas.solutions.di.studio.rpp.jobs.plan.UpdatePromotionPlanJob.execute(UpdatePromotionPlanJob.java:51) at com.sas.solutions.di.commons.jobs.AbstractJob.internalExecute(AbstractJob.java:454) at com.sas.solutions.di.commons.jobs.AbstractJob.run(AbstractJob.java:420) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "DI_DM"."RPP_PLAN_OPT_SETTING"."OPT_PARM_VALUE" (actual: 83, maximum: 20)

The exception is generated when a promotion contains a product whose product ID is greater than 20 characters.

Contact Technical Support for a workaround for this issue.

A fix for this issue is planned for a future software release.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.2_M25.49.3 TS1M29.4 TS1M4
Linux for x645.2_M25.49.3 TS1M29.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.